<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>  
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <title>Wild Fire Learning Solutions</title>
  <link href="css/style.css" rel="stylesheet" type="text/css" />
  <script src="datafeed.js" type="text/javascript"></script>
  <script language="JavaScript" src="pop-up.js"></script>
</head>


<body>
<?php
//############################################
//Now import the settings
include_once("settings.php");

//############################################
//Connect to the db
mysql_connect($db_host,$MySqlUN,$MySqlPW);
@mysql_select_db($database) or die( "Unable to select databases");

$query = "SELECT * from products";
$results = mysql_query($query) or die(mysql_error());

?>
<div id="contain">
	<?php include("header.php"); ?>

<!--Navigation and LHS-->
	<div id="leftcol">
		<?php include("menu.php"); ?>
	</div>
<!-- Nav ends -->

<!-- Content (RHS) -->
<div id="content">
<h4> Products</h4>
<p>List the products that your company offers. To add more products, copy and paste additional text boxes.</p>
<br>
<p>
	<table class="outerpro">
	<?php

	//show only name, price and image
	while($row = mysql_fetch_array($results)) {
	extract($row);
	echo "<tr><td rowspan=\"2\">";
	echo "<img src=\"images/pro1.jpg\" /></td>";
	echo "<td valign=\"top\"><b>";
	echo $products_name;
	echo "</b><br><br>";
	echo "</td>";
	echo "</tr>";
	echo "<tr>";
	echo "<td valign=\"top\">";
	echo "<table class=\"product\">";
	echo "<tr>";
	echo "<td>";
	echo "SKU/Item Number: 000000";
	echo "</td>";
	echo "<td><ul><li><a href=\"javascript:popcontact('addcart.php?prodid=" . $products_prodnum . " ')\">More</a></li></ul></td>";	
	echo "<td><b>";
	echo "Price:$" . $products_price;
	echo "</b></td>";
	echo "<td align=\"right\" valign=\"top\">";
	echo "<a href=\"getprod.php?prodid=" . $products_prodnum . "\">";
	echo "<img src=\"images/shopping_cart.jpg\" border=\"0\"><br>Add to cart</a></b></td>";
	echo "</tr>";
	echo "</table>";
	echo "</td>";
	echo "</tr>";
	
	}
	?>
	
	</table>
</p>
</div>
<!-- content ends (RHS) -->
<?php include("footer.php"); ?>
</div>
</body>
</html>